In [211]:
import pandas as pd
import plotly.express as px
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
import os
import umap
import glob
import ast
%matplotlib inline
In [44]:
delhi=pd.read_csv("delhi-corona-news-cleaned.csv",index_col=0)
kolkata=pd.read_csv("kolkata-corona-news-cleaned.csv",index_col=0)
chennai=pd.read_csv("chennai-corona-news-cleaned.csv",index_col=0)
hyderabad=pd.read_csv("hyderabad-corona-news-cleaned.csv",index_col=0)
mumbai=pd.read_csv("mumbai-corona-news-cleaned.csv",index_col=0)
bengaluru=pd.read_csv("bengaluru-corona-news-cleaned.csv",index_col=0)

News Analysis As Follows

1)See the percentage of each emotion per week 
2)Explored the fear and anger emotion pattern over weeks
3)See number of news for each emotions in different cities
4)Explored fear peaks and respective news for different cities
5)We found disappointing and depressing news pattern in the respective cities and verifiy it by checking original feeds
6)We found frustrating news patterns in the respective cities and verifiy it by checking original feeds
In [169]:
fig,ax=plt.subplots(2,3,figsize=(40,25))
ax[0][0].stackplot(delhi.index,delhi.fear_percentage,delhi.anger_percentage,delhi.sadness_percentage,delhi.joy_percentage,delhi.surprise_percentage) 
ax[0,0].tick_params(labelrotation=40)
ax[0][1].stackplot(mumbai.index,mumbai.fear_percentage,mumbai.anger_percentage,mumbai.sadness_percentage,mumbai.joy_percentage,mumbai.surprise_percentage)
ax[0,1].tick_params(labelrotation=40)
ax[0][2].stackplot(bengaluru.index,bengaluru.fear_percentage,bengaluru.anger_percentage,bengaluru.sadness_percentage,bengaluru.joy_percentage,bengaluru.surprise_percentage)
ax[0,2].tick_params(labelrotation=40)
ax[1][0].stackplot(kolkata.index,kolkata.fear_percentage,kolkata.anger_percentage,kolkata.sadness_percentage,kolkata.joy_percentage,kolkata.surprise_percentage)
ax[1,0].tick_params(labelrotation=40)
ax[1][1].stackplot(chennai.index,chennai.fear_percentage,chennai.anger_percentage,chennai.sadness_percentage,chennai.joy_percentage,chennai.surprise_percentage)
ax[1,1].tick_params(labelrotation=40)
ax[1][2].stackplot(hyderabad.index,hyderabad.fear_percentage,hyderabad.anger_percentage,hyderabad.sadness_percentage,hyderabad.joy_percentage,hyderabad.surprise_percentage)
ax[1,2].tick_params(labelrotation=40)
plt.legend(["Fear","Anger","Sadness","Joy","Surprise"],prop={'size': 30})
ax[0,0].set_title('Delhi',fontsize=40)
ax[0,1].set_title('Mumbai',fontsize=40)
ax[0,2].set_title('Bengaluru',fontsize=40)
ax[1,0].set_title('Kolkata',fontsize=40)
ax[1,1].set_title('Chennai',fontsize=40)
ax[1,2].set_title('Hyderabad',fontsize=40)
fig.suptitle('Emotion Percentage On Per Week News', fontsize=60)
plt.show()
fig.savefig("News-sentiment-6cities.png")
In [216]:
fig,ax=plt.subplots(2,3,figsize=(40,25))
ax[0][0].plot(delhi.index,delhi.fear) 
ax[0][0].plot(delhi.index,delhi.anger) 
ax[0,0].tick_params(labelrotation=40)
ax[0][1].plot(mumbai.index,mumbai.fear)
ax[0][1].plot(mumbai.index,mumbai.anger)
ax[0,1].tick_params(labelrotation=40)
ax[0][2].plot(kolkata.index,kolkata.fear)
ax[0][2].plot(kolkata.index,kolkata.anger)
ax[0,2].tick_params(labelrotation=40)
ax[1][0].plot(bengaluru.index,bengaluru.fear)
ax[1][0].plot(bengaluru.index,bengaluru.anger)
ax[1,0].tick_params(labelrotation=40)
ax[1][1].plot(chennai.index,chennai.fear)
ax[1][1].plot(chennai.index,chennai.anger)
ax[1,1].tick_params(labelrotation=40)
ax[1][2].plot(hyderabad.index,hyderabad.fear)
ax[1][2].plot(hyderabad.index,hyderabad.anger)
ax[1,2].tick_params(labelrotation=40)
plt.legend(["Fear","Anger","Sadness","Joy","Surprise"],prop={'size': 30})
ax[0,0].set_title('Delhi',fontsize=40)
ax[0,1].set_title('Mumbai',fontsize=40)
ax[0,2].set_title('Kolkata',fontsize=40)
ax[1,0].set_title('Bengaluru',fontsize=40)
ax[1,1].set_title('Chennai',fontsize=40)
ax[1,2].set_title('Hyderabad',fontsize=40)
fig.suptitle('Trend Of Fear News Per Week', fontsize=60)
plt.show()
fig.savefig("Fear-6cities.png")
In [238]:
plt.figure(figsize=(20,5))
plt.plot(delhi.index,delhi.fear)
plt.xticks(rotation=50)
plt.plot(delhi.index,delhi.anger)
plt.plot(delhi.index,delhi.sadness)
plt.plot(delhi.index,delhi.joy)
plt.plot(delhi.index,delhi.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("Delhi News Emotion Per Week",fontsize=30)
plt.savefig("delhi-emotion.png")
In [239]:
plt.figure(figsize=(20,5))
plt.plot(mumbai.index,mumbai.fear)
plt.xticks(rotation=50)
plt.plot(mumbai.index,mumbai.anger)
plt.plot(mumbai.index,mumbai.sadness)
plt.plot(mumbai.index,mumbai.joy)
plt.plot(mumbai.index,mumbai.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("Mumbai News Emotion Per Week",fontsize=30)
plt.savefig("Mumbai-emotion.png")
In [240]:
plt.figure(figsize=(20,5))
plt.plot(bengaluru.index,bengaluru.fear)
plt.xticks(rotation=50)
plt.plot(bengaluru.index,bengaluru.anger)
plt.plot(bengaluru.index,bengaluru.sadness)
plt.plot(bengaluru.index,bengaluru.joy)
plt.plot(bengaluru.index,bengaluru.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("bengaluru News Emotion Per Week",fontsize=30)
plt.savefig("bengaluru-emotion.png")
In [241]:
plt.figure(figsize=(20,5))
plt.plot(kolkata.index,kolkata.fear)
plt.xticks(rotation=50)
plt.plot(kolkata.index,kolkata.anger)
plt.plot(kolkata.index,kolkata.sadness)
plt.plot(kolkata.index,kolkata.joy)
plt.plot(kolkata.index,kolkata.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("kolkata News Emotion Per Week",fontsize=30)
plt.savefig("kolkata-emotion.png")
In [242]:
plt.figure(figsize=(20,5))
plt.plot(chennai.index,chennai.fear)
plt.xticks(rotation=50)
plt.plot(chennai.index,chennai.anger)
plt.plot(chennai.index,chennai.sadness)
plt.plot(chennai.index,chennai.joy)
plt.plot(chennai.index,chennai.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("chennai News Emotion Per Week",fontsize=30)
plt.savefig("chennai-emotion.png")
In [243]:
plt.figure(figsize=(20,5))
plt.plot(hyderabad.index,hyderabad.fear)
plt.xticks(rotation=50)
plt.plot(hyderabad.index,hyderabad.anger)
plt.plot(hyderabad.index,hyderabad.sadness)
plt.plot(hyderabad.index,hyderabad.joy)
plt.plot(hyderabad.index,hyderabad.surprise)
plt.legend(["Fear","Anger","Sadness","joy","Surprise"])
plt.title("hyderabad News Emotion Per Week",fontsize=30)
plt.savefig("hyderabad-emotion.png")

Lets Explore Peaks In Respective Cities

Delhi

In [222]:
ast.literal_eval(delhi[delhi.index=="2020-03-16 00:00:00"].news.values[0])
Out[222]:
['SDMC plans curbs to step up coronavirus fight',
 'Waste To Wonder Park open; but coronavirus scare leads to dip in footfall',
 'Coronavirus scare in Delhi: Four cases prompt survey in busy Janakpuri hub',
 'Covid-19 in Delhi: Sanitisation paper must for interstate buses; says government',
 'Coronavirus scare in Delhi: Jamia Millia Islamia fully shut; students asked to go home',
 'Coronavirus in Delhi: At NCDC control room; phones ringing non-stop',
 "Coronavirus: 'Got reluctant response after trying helplines for 30 minutes'",
 'Covid-19 outbreak: Delhi government to check hoarding of sanitisers; fine violators',
 'Covid-19 in Delhi: Three corporations invoke emergency clause; insist on hand wash points',
 'Coronavirus scare in Delhi: Daily metro footfall down by almost 10 lakh',
 'Covid-19: Only a few courtrooms to stay functional at Delhi high court this week',
 'Covid-19: App-based cabbies seek better protection',
 'Coronavirus scare in Delhi: Shaheen Bagh women may cap number of protesters',
 'Delhi: In coronavirus time; worshippers told not to ignore safety tips',
 'Covid-19 scare in Delhi: Over six hours at IGI without water or food; no access to washrooms',
 'Covid- 19 scare: Inform about foreigner patients; Delhi government tells private hospitals; nursing homes',
 'Covid-19 in Delhi: Three hotels near IGI Airport chosen to offer paid isolation facilities',
 'Saket man 8th person to test positive for Covid-19 in capital',
 'Coronavirus scare in Delhi: SDMC shuts wonder park; Nandan Van',
 'Coronavirus scare: 1.5 lakh vendors to be hit by closure of weekly markets in Delhi',
 'Covid-19 threat: Delhi high court bars law interns from entering premises; for now',
 "#CoronaFear: The one time when being 'foreign-returned' isn't cool",
 'Coronavirus: Private labs can inject life into fight',
 'No community transmission of Covid-19 in India so far',
 'Coronavirus in Delhi: 10 more government hospitals to collect Covid-19 samples',
 'Lonely in time of corona: Elders fear further isolation',
 'Coronavirus scare: Shaheen Bagh protesters keep distance; but stay put',
 'Covid-19 in Delhi: Restaurants down shutters for the month',
 'Coronavirus count: One more in Delhi; two each in Gurugram; Noida',
 'Drug to treat inflammation may worsen Covid-19',
 'What awaits those flying in from coronavirus hotspots',
 'Coronavirus outbreak: Daily ridership in buses declines by 4 lakh in March',
 "Covid-19 scare in Delhi: Vendors' woes multiply by the day as losses mount",
 'Coronavirus forces closure of Delhi zoo till March 31',
 'Coronavirus outbreak in Delhi: Manjinder Singh Sirsa urges Arvind Kejriwal to help out daily wagers',
 'Coronavirus outbreak in Delhi: Sanitise premises; govt tells schools',
 'Covid-19 cases in Delhi: Disinfection drives in open gyms; parks',
 'Coronavirus in Delhi: Rumours send people rushing for groceries',
 'Covid-19 in Delhi: For restaurant owners & staff; a recipe for disaster',
 'covid 19 patient ends life in safdarjung hospital delhi ncr cases rise to 19',
 'Coronavirus outbreak: 1;300 hand sanitisation points in place across south Delhi',
 'Coronavirus scare in Delhi: Services at RTOs to be curtailed',
 'Coronavirus scare in Delhi: Rumours make people rush for bulk buying',
 'Covid-19 outbreak: AIIMS doctors make sanitisers to beat shortfall',
 'Coronavirus in Delhi: Hospitals may pool resources for ICU needs',
 "Covid-19 scare: Bus frequency won't be curtailed as it will result in crowding; says Delhi CM Arvind Kejriwal",
 'How Delhi is closing down to shut out coronavirus',
 'Covid-19 outbreak: Entire education system halted',
 'Coronavirus sacre: Avoid travelling by metro unless unavoidable; says DMRC',
 'Coronavirus outbreak: Ensure availability of medicines;says Delhi CM Arvind Kejriwal',
 'Covid-19 in Delhi: AIIMS; RML and Lady Hardinge to suspend non-essential surgeries',
 'Coronavirus scacre: DJB suspends billing; meter reading; sops to continue',
 'Coronavirus outbreak in Delhi: Restaurants serving food will be booked; sealed',
 'Coronavirus outbreak in Delhi: Corporations order closure of weekly markets; salons',
 'At six; Delhi reports most Covid-19 cases in a day',
 'Covid-19 in Delhi: Social distancing not on track yet',
 'Coronavirus outbreak: Not all can work from home or afford to take cab',
 'Coronavirus outbreak: Students left in the lurch after JNU; DU; Jamia Millia Islamia close hostels',
 'Coronavirus in Delhi: Satyendar Jain inspects quarantine facilities; tells officials to ensure all basic amenities',
 'Before Sunday curfew; seven new coronavirus cases in Delhi',
 'Covid-19: Consultations on online platforms see 50% increase',
 'Coronavirus in Delhi: Shops down shutters; but essential services running',
 'To soften coronavirus blow; Delhi government increases ration; doubles pensions',
 'coronavirus outbreak delhi budget to be placed and passed in one day session']
In [212]:
#Mumbai
ast.literal_eval(mumbai[mumbai.index=="2020-03-16 00:00:00"].news.values[0])
Out[212]:
['coronavirus scare in mumbai cops ban tours in and out of city under section 144',
 'Coronavirus outbreak: Mumbai businesswoman loses Rs 4 lakh in online face mask order',
 'Coronavirus in Mumbai: Home quarantine for over 700 proves easier said than done',
 'Coronavirus: Several Mumbai schools shift studies and projects to virtual classrooms',
 'Covid-19: College; university exams in Mumbai postponed till March 31',
 'Covid-19: E-papers at Kalyan',
 'Coronavirus scare: Public spaces in Mumbai off-limits or open for limited hours',
 'Covid-19 Impact: US Cos may require additional compliance to cover H-1B employees in their work from home policies',
 'Pvt firms get infra ready to handle Covid-19 testing',
 'Covid-19 outbreak: Central Railway cancels 23 long-distance trains',
 'Covid-19 in Maharashtra: Prayers; discourses move online',
 "Coronavirus scare: Maharashtra govt plans to allow quarantine unit in Mumbai's SevenHills Hospital",
 'Covid-19 in Mumbai: KEM Hospital to start testing; 20 new beds in Jogeshwari',
 'Coronavirus scare: Avoid needless travel or will stop trains; says Maharashtra CM Uddhav Thackeray',
 'Coronavirus in Mumbai: Pubs; bars closed; some eateries may shut',
 "Coronavirus outbreak: KEM Hospital; Haffkine Institute to start tests today; up Mumbai's capacity to 300 samples a day",
 'Covid-19 in Maharashtra: Class X exams held with sanitisers at hand',
 'Covid-19 in Maharashtra: School closure stops midday meals for kids; SC sends notice',
 'Coronavirus outbreak: Mumbai prepares to quarantine 26;000 Indians coming from Gulf',
 'Covid-19 scare: BMC directs nine private hospitals to start isolation wards',
 'Covid-19 scare: Mumbai schools start promoting students of classes I to VIII',
 'Hostels; guest houses to be used for quarantine',
 'Covid-19 in Mumbai: Hostels; guest houses to be used for quarantine',
 'Covid-19 outbreak: Dharavi man may face arrest for defying home quarantine',
 "Coronavirus in Mumbai: 'No need for panic buying; there's enough supply'",
 "Coronavirus: 'Janata curfew' may leave few public transport options for Mumbai",
 'Bandra getting quarantine facility for Covid-19 patients as numbers increase',
 'Covid-19 outbreak: Sunni leaders seek suspension of prayers at Mumbai mosques',
 'Cut AC use to stall coronavirus: Maharashtra health minister to government offices',
 'Coronavirus: General public not allowed in Mumbai local trains from Sunday',
 'Covid-19 outbreak in Mumbai: Eight private hospitals can screen and collect swabs',
 'Coronavirus in Mumbai: Five caught; sent to forced quarantine after neighbours complain to BMC; cops',
 "Covid-19: Mumbaikars stay indoors as 'Janta Curfew' commences",
 "Passengers with 'home quarantine' seal offloaded from trains; BEST bus",
 'Covid-19 scare: Early negative test is not final; day 5 and 14 results key; says BMC',
 'Coronavirus outbreak in Maharashtra: Now; home checks on quarantined',
 'Covid-19 scare in Mumbai: No donation drives; blood in short supply']
In [220]:
#kolkata
ast.literal_eval(kolkata[kolkata.index=="2020-03-16 00:00:00"].news.values[0])
Out[220]:
['Kolkata: Victoria; Indian Museum shut down amid coronavirus-spread fear',
 'Coronavirus scare in Kolkata: Temples take steps to curb crowds on premises',
 'Covid-19 in Kolkata: KMC closes swimming pools till month-end',
 'Covid-19 in West Bengal: Border vigil beefed up; movement restricted',
 "Coronavirus scare: Woman returns from Mecca with fever; flees from Bengal's ID hospital",
 'West Bengal likely to requisition 52 flats; plans 500 more quarantine beds',
 'Coronavirus in Kolkata: City stares at Rs 440 crore business jolt',
 'Kolkata: Private facilities pad up to fight coronavirus',
 'Educational institutes look at calendar tweak to beat coronavirus shutdown',
 "Coronavirus scare: Jeet; Mimi cut short 'Baazi' shoot in London",
 "West Bengal panel checks private hosps' coronavirus preparedness",
 'Kolkata: Coronavirus lockdown fear sets off panic buying of staple items',
 'Coronavirus scare: Sanitisers; paper tissues replace finger bowls; napkins at eateries',
 'Face police action if you spread coronavirus rumours in Kolkata',
 'Coronavirus scare in Kolkata: 24 ID cabins with attached toilets have hosted over 50',
 'Covid-19 outbreak: Stuck in foreign lands; Kolkatans race against time to return home',
 'Covid-19 scare in Kolkata: Clubs take preventive steps but put responsibility onus on members',
 'Kolkata on Covid-19 map; teen back from UK tests positive',
 "Coronavirus scare: In Kolkata; 'Gaumutra' lands cop in hospital; local BJP organiser behind bars",
 'Covid-19 scare in Kolkata: Condominium on sanitisation overdrive to check virus spread',
 "Nabanna cleans up after office visit by Covid-19 boy's bureaucrat mother",
 'ID refers two to NRS as number of Covid-19 suspects exceeds beds',
 "Covid-19 scare in West Bengal: State employees' office time cut short by an hour",
 'Coronavirus scare: Kolkata churches bring changes to Lent prayers and services',
 'Strangers join hands to help the elderly in times of corona crisis',
 'Coronavirus in Kolkata: Next 8-10 days critical in fight against disease; says doctors',
 'Coronavirus in Kolkata: Crowded hospitals beat concept of social distancing; say doctors',
 'Co-flyers of Covid-19 positive teen traced; all advised home isolation',
 'Coronavirus scare in West Bengal: Schools form attendance module for teachers',
 'Ships from 15 countries to face quarantine',
 'Coronavirus scare: Calcutta University; Presidency University defer exams; others may follow suit',
 'Early start at New Town quarantine centre as flyers from Gulf check in',
 'Kolkata: Gated communities step up fight against coronavirus',
 "Covid-19 scare in Kolkata: Techie faces locals' wrath after return from Finland",
 'Covid-19 in Kolkata: Challenges ahead to enforce quarantine',
 'Kolkata: Premier clubs declare temporary closure to keep coronavirus at bay',
 'Salt Lake civic body kicks off coronavirus awareness campaign',
 'Covid-19 in Kolkata: Harrowing time for suspect seeking a bed in government hospital',
 'Coronavirus in Kolkata: No mass; church services till March 31',
 'Coronavirus in West Bengal: Bars; eateries; clubs asked to shut down till March 31',
 'Four Kolkata doctors face flak for flouting coronavirus norm',
 'Virus at doorstep; S Kol condo living on phone',
 'In view of coronavirus outbreak; West Bengal government postpones HS exams; new dates to be declared after April 15',
 'Amid coronavirus scare; Kolkata begins to heal its air and water quality',
 'Coronavirus curbs trigger prison riot in Kolkata; one shot; eight hurt',
 'Man with no travel history tests coronavirus positive; West Bengal count at 4',
 'Coronavirus scare: Stop inter-state trains; says West Bengal CM']

Disappointment and Depressing News Can Be Seen When Fear in the news is high and anger in the news is low

image.png

Lets Checkout

In [224]:
#Delhi
ast.literal_eval(delhi[delhi.index=="2020-04-27 00:00:00"].news.values[0])
Out[224]:
['Delhi: Strict vigil during Ramzan to maintain lockdown rules',
 "Why Jahangirpuri is Delhi's biggest Covid-19 hotspot",
 'Delhi: Hospitals become hotspots as Covid care exacts heavy price',
 'Masks; PPE kits must for cops on Covid duty',
 "Two food volunteers test Covid-19 positive in Delhi's Mehrauli",
 "Corona scare: Delhi hospitals turn away family of 'dying' man",
 'Covid-19: Containment zones hit the century mark',
 "This 'Akashvani' warns lockdown violators to get off south Delhi roads",
 'Covid-19: Delhi government says trials for plasma therapy to go on',
 'Revert to open court hearing after lockdown',
 'Entire CRPF battalion quarantined in Delhi',
 '13 healthcare workers test Covid-19 positive at Safdarjung Hospital in last two months',
 'Coronavirus: Samples pending for tests in Delhi up 7 times in 1 month',
 'Delhi government retracts order asking doctors to show cause of testing positive for Covid-19',
 'coronavirus in delhi latest news updates on delhi corona cases deaths 02 may 2020',
 'Coronavirus outbreak: Jamia tells students in hostels to return home',
 'Delhi: 41 Covid +ve cases in Kapashera building set off alarm bells',
 'Covid-19 lockdown in Delhi: RWAs hesitant to take call on domestic helps']
In [226]:
#Bengaluru
ast.literal_eval(bengaluru[bengaluru.index=="2020-04-13 00:00:00"].news.values[0])
Out[226]:
["Felines susceptible to Coronavirus: Bengaluru's animal experts recommend safety protocol for pets; too",
 "At 2.6%; Karnataka's Covid-19 fatality rate lower than national average",
 'Quarantined auto driver plays truant; leaves officials jittery',
 "As lockdown extension looms large; food insecurity haunts Bengaluru's poor",
 '19 Covid-19 patients in Karnataka are below 14 years',
 'Bengaluru: Virus fear keeps haemophiliacs away from Victoria Hospital',
 'Karnataka: Stricter lockdown in week ahead; says CM BS Yediyurappa',
 "Bengaluru: 'Dad dead' lie got him past cops; but not coronavirus",
 'Coronavirus: Mysuru district pips Bengaluru; logs most active cases; Bagalkot cop tests positive',
 "City corporates ensure employees' well-being during lockdown with fun activities",
 '#Coronaconcern: Fear of transmission has pet parents abandoning pets',
 'Bengaluru: Turned away by 2 hospitals on Covid-19 fear; woman gives birth in third']

Frustration News Can Be Seen When Fear in the news is low and anger in the news is high

pattern1.jpg Let's Check

In [234]:
#Chennai
ast.literal_eval(chennai.iloc[16].news)
#it is showing low fear and higher anger 
Out[234]:
['Tamil Nadu: No new Covid-19 case in 13 districts; but fingers crossed',
 'Central team takes stock of Covid-19 readiness in Chennai',
 'Ramzan diets for diabetics; those in Covid-19 isolation',
 'TN govt not in a hurry to lift lockdown fully',
 'What the Covid map tells about Tamil Nadu',
 'Tamil Nadu for staggered lockdown exit after May 3',
 "Remote pacemakers ensure doctors don't skip a beat during lockdown",
 'Veggie markets a problem; people not serious about Covid-19: EPS',
 '90 fishermen embark on 1;000km voyage to escape lockdown in Tamil Nadu',
 'Covid impact: Fumigation; disinfection costs double',
 'Disregard for lockdown norms triggers clusters in Chennai',
 'As Tamil Nadu awaits lockdown exit; cases hit 161 in one day; 138 in Chennai',
 'Coronavirus spreading fast in Chennai; case count crosses 1;000-mark',
 'PG medical students yet to get Covid-19 test results; live in fear',
 'Coronavirus in Chennai: Police clip wings of lockdown violators with drones',
 'Indoor pollution from firewood poses higher Covid risk: Researchers',
 'coronavirus in chennai latest news updates on chennai corona cases deaths 02 may 2020',
 'Chennai: Covid-19 warriors to get tributes from sky and sea',
 'Living with fear: Nurse on Covid-19 duty narrates his experience',
 'One fireman; five more cops test coronavirus positive in Tamil Nadu']
In [236]:
#Hyderabad
ast.literal_eval(chennai[chennai.index=="2020-06-08 00:00:00"].news.values[0])
#similarly news shows same feelings 
#Does it some what frustrating??
Out[236]:
['Quality control: Covid-19 test results of all labs in Tamil Nadu to be reviewed randomly',
 'Covid-19: Unknown sources; high numbers in Tamil Nadu raise questions',
 'Onus on community to stop Covid-19 spread in Tamil Nadu',
 'For first time; Tamil Nadu records over 1;500 Covid-19 cases in a day',
 'Chennai registers 75% fewer deaths during lockdown',
 "Chennai-based runners' group organises virtual marathon to ease runners into post-Covid world",
 "Chennai: Corporation's Covid warriors lost in maze of forms and formalities",
 'Chennai K-pop fans dance away to a virtual face-off in the lockdown',
 "Surge in Covid-19 cases to test Tamil Nadu's medical mettle",
 'Min: Virus spreading at lightning speed in TN',
 '236 Covid-19 deaths in Chennai not recorded by Tamil Nadu government',
 'Work to restore Puzhuthivakkam lake; stalled by Covid; resumes',
 'Why TN must come clean on Covid deaths',
 "Chennai: Daughters design 'quarantine room' for dad who returned from Spain",
 'Anbazhagan passes away on his birthday; 1st MLA to die of coronavirus',
 "Covid-19: Tamil Nadu's highest one-day tally of 1;927 takes count beyond 36;000",
 'State mines data to get its Covid death toll right',
 'Tamil Nadu diverts Rs 376 crore savings of World Bank scheme to fight Covid-19',
 "Can't Chennai alone be under lockdown; Madras HC asks Tamil Nadu",
 'Fighting Covid-19: What Chennai can learn from Bengaluru',
 'Tamil Nadu government divided over intense lockdown in Chennai',
 'Tamil Nadu: How a sugarcane farmer ensured a sweet time during lockdown',
 'Rumours of new lockdown make bizmen anxious',
 '40 booked for violating home quarantine norms in Chennai',
 'Covid-19: 1;982 fresh positive cases in Tamil Nadu; low-risk Chennai cases must wait for hospital beds',
 'No lockdown for now: Tamil Nadu to Madras high court; EPS junks posts on social media',
 'More strays being run over as lockdown eases in Chennai',
 'Chennai corporation has no idea where 277 Covid-19 positive patients are',
 'Covid deaths cross 9;000; 12;000+ cases on Saturday',
 'lockdown impact covid 19 cases dip in chennai']